Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
Production ProductProductPhoto (table)
Print
RSS
Modified on 2011/08/27 11:18
by
wikibot
Categorized as
Uncategorized
dbo Flag (type)
Production (schema)
Production Product (table)
Production ProductPhoto (table)
dbo Flag (type)
Production (schema)
Production Product (table)
Production ProductPhoto (table)
»
Production ProductProductPhoto (table)
[X]
»
Production ProductProductPhoto (table)
wikibot
¶
Table
Production.ProductProductPhoto
Description
Cross-reference table mapping products and product photos.
Columns
¶
Column
Data Type
Nullable
Default
Description
ProductID
int
not null
Product identification number. Foreign key to Product.ProductID.
ProductPhotoID
int
not null
Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.
Primary
dbo.Flag
not null
((0))
0 = Photo is not the principal image. 1 = Photo is the principal image.
ModifiedDate
datetime
not null
(getdate())
Date and time the record was last updated.
Primary Key
¶
Primary Key
Columns
PK_ProductProductPhoto_ProductID_ProductPhotoID
ProductID, ProductPhotoID
Foreign Keys
¶
Relation
Column
Referenced Column
Production.Product
ProductID
ProductID
Production.ProductPhoto
ProductPhotoID
ProductPhotoID
References
¶
Dependency Type
Object Type
Referenced Object
Data Type
Type
dbo.Flag
Schema
Schema
Production
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.